{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":110,"n_cols":10,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Quadro do Projecto Hotel"]
[null,"Ex. 5.10 - Sim. Projecto Hotel ",null,null,null,null,null,"(100 Runs)"]
[]
[null,null,"Tx Actualização",null,{"$f":"0.1","v":0.1}]
[null,null,"NPV(0,1) - Mil €",null,{"$f":"NPV(E5,F13:F20)","v":-715.40140819729663},null,null,"Run","NPV - Mil €","TIR - %"]
[null,null,"IRR (%)",null,{"$f":"IRR(F13:F20)*100","v":2.4906856481494488},null,null,"Média",{"$f":"AVERAGE(I10:I110)","v":477.49254451470233},{"$f":"AVERAGE(J10:J110)","v":12.918179793836524}]
[null,null,null,null,null,null,null,"D. Padrão (*)",{"$f":"STDEV(I10:I110)","v":879.25332627352191},{"$f":"STDEV(J10:J110)","v":6.5493919489358392}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+E6","v":-715.40140819729663},{"$f":"+E7","v":2.4906856481494488}]
[null,null,null,null,null,null,null,1,795.92273992503283,16.094709858959753]
[null,"Ano",null,"Cash - Flow (Mil €)",null,"Gerado",null,{"$f":"+H11+1","v":2},2185.8888974886868,24.197286215384107]
[null,0,"Normal(μ;σ)",-800,null,{"$f":"+D13","v":-800},null,{"$f":"+H12+1","v":3},-128.4045581977216,8.8512745561421866]
[null,1,"Normal(μ;σ)",-800,50,{"$f":"NORMINV(RAND(),D14,E14)","v":-868.9501439085476},null,4,656.22489927311221,15.014550029229357]
[null,2,"Normal(μ;σ)",-800,100,-728.52792389799004,null,5,-577.05523526500156,4.5573337961822391]
[null,3,"Normal(μ;σ)",-700,150,-577.2954554149228,null,6,-204.33474602472208,8.2809918320872367]
[null,4,"Normal(μ;σ)",300,200,293.27780476153646,null,7,46.8592506977364,10.407919542173083]
[null,5,"Normal(μ;σ)",400,200,420.04467180838907,null,8,-372.38907806637928,6.8250003401179926]
[null,6,"Normal(μ;σ)",500,200,310.77029336650168,null,9,34.270913801500761,10.2850458370926]
[null,7,"Uniforme(a;b",2000,8440,{"$f":"+D20+RAND()*(E20-D20)","v":2342.9110618838376},null,10,-358.20020570336465,6.9635112173907832]
[null,null,null,null,null,null,null,11,319.95106057720142,12.535452954909566]
[null,null,null,null,null,null,null,12,12.218085073432327,10.115306734830742]
[null,null,null,null,null,null,null,13,1455.351922830585,18.921665645455455]
[null,"Intervalo de Confiança a ",null,0.95,null,null,null,14,-165.60895203083106,8.5383303264424661]
[null,null,null,null,null,null,null,15,576.83314219955344,14.467287140400465]
[null,"NPV",null,null,"IRR",null,null,16,1901.6187702570046,22.921500250978653]
[null,"L. Inferior","L. Superior",null,"L. Inferior","L. Superior",null,17,1280.1229760270692,19.472247812481026]
[null,null,null,null,null,null,null,18,-223.83984592218644,7.9717005935830532]
[null,{"$f":"+$I$7-$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":303.02960904163587},{"$f":"+$I$7+$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":651.95547998776874},null,{"$f":"+$J$7-$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":11.618638341070316},{"$f":"+$J$7+$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":14.217721246602732},null,19,1562.8932566536287,20.556869716739691]
[null,null,null,null,null,null,null,20,245.05506267171663,12.062716038430278]
[null,null,null,null,null,null,null,21,-218.7962908513253,8.2501206537768823]
[null,"(*) O Excel já dá o Desvio Padrão Corrigido.",null,null,null,null,null,22,1248.8993645139283,18.763546337247551]
[null,null,null,null,null,null,null,23,1312.9872098214598,19.120496523850395]
[null,null,null,null,null,null,null,24,-852.65757778620207,2.6394763019320644]
[null,null,null,null,null,null,null,25,1129.3744906516852,18.308413534409283]
[null,null,null,null,null,null,null,26,-520.26622446952092,4.7074949786176878]
[null,null,null,null,null,null,null,27,977.34465698123222,17.4252552311569]
[null,null,null,null,null,null,null,28,448.96199112781375,13.58299894546089]
[null,null,null,null,null,null,null,29,277.15636231577594,12.247142548900914]
[null,null,null,null,null,null,null,30,-409.30776099762437,6.2569708712741923]
[null,null,null,null,null,null,null,31,94.012762144120629,10.746883392383477]
[null,null,null,null,null,null,null,32,553.11986550735367,14.261358003683711]
[null,null,null,null,null,null,null,33,382.78477335904154,13.219815764085618]
[null,null,null,null,null,null,null,34,286.95639498943694,12.343894832553804]
[null,null,null,null,null,null,null,35,575.11263558081259,14.781009894768872]
[null,null,null,null,null,null,null,36,1321.4383140489845,19.289713556442891]
[null,null,null,null,null,null,null,37,1797.7429495726922,22.383592157150801]
[null,null,null,null,null,null,null,38,-171.20866346969561,8.4484033395818781]
[null,null,null,null,null,null,null,39,-393.4900486929663,6.4818321867682327]
[null,null,null,null,null,null,null,40,-424.47056894127087,6.395113859528645]
[null,null,null,null,null,null,null,41,1387.900781841254,19.972905938898244]
[null,null,null,null,null,null,null,42,1227.2029571363769,18.190469888331684]
[null,null,null,null,null,null,null,43,706.11893257754252,15.92506382518164]
[null,null,null,null,null,null,null,44,1816.9284903452597,21.883889733235364]
[null,null,null,null,null,null,null,45,1327.2879555176019,19.137487357561177]
[null,null,null,null,null,null,null,46,1854.1350270764297,22.378943130084039]
[null,null,null,null,null,null,null,47,1861.5058663245702,22.631977659810197]
[null,null,null,null,null,null,null,48,1687.3188477503381,20.785710561418625]
[null,null,null,null,null,null,null,49,-715.3034379425734,2.8977492673471605]
[null,null,null,null,null,null,null,50,2130.970747575951,23.623656864819019]
[null,null,null,null,null,null,null,51,889.94816774155254,16.386723290750549]
[null,null,null,null,null,null,null,52,1027.1006033193089,16.76713373145413]
[null,null,null,null,null,null,null,53,-1013.5284968611443,-1.4571095318833382]
[null,null,null,null,null,null,null,54,-73.601753599454725,9.3437008619769557]
[null,null,null,null,null,null,null,55,1877.5801484867879,22.245194363634681]
[null,null,null,null,null,null,null,56,-436.82628297687637,5.620020081084065]
[null,null,null,null,null,null,null,57,1197.445948930535,18.499053074784477]
[null,null,null,null,null,null,null,58,2173.4843254077741,24.255837013269279]
[null,null,null,null,null,null,null,59,-447.16487438950622,5.5058730053679117]
[null,null,null,null,null,null,null,60,561.78228723488701,14.286065991011544]
[null,null,null,null,null,null,null,61,448.55330544977255,13.98326858175114]
[null,null,null,null,null,null,null,62,1768.7120149076793,22.440083775233855]
[null,null,null,null,null,null,null,63,-396.86090181853467,6.3512512453460568]
[null,null,null,null,null,null,null,64,1484.3180205591684,20.176598844534112]
[null,null,null,null,null,null,null,65,-229.91129411276253,7.8167063292509775]
[null,null,null,null,null,null,null,66,-432.33421011948951,5.9270197779601297]
[null,null,null,null,null,null,null,{"$f":"+H76+1","v":67},2110.9452772686204,23.846812194332045]
[null,null,null,null,null,null,null,68,734.88941657462044,15.130648305428274]
[null,null,null,null,null,null,null,69,529.03166553688868,14.325398603625562]
[null,null,null,null,null,null,null,70,459.49116963589444,13.833844633310433]
[null,null,null,null,null,null,null,71,2028.0901516251583,23.09352173946888]
[null,null,null,null,null,null,null,72,824.35275974512103,16.32524809496423]
[null,null,null,null,null,null,null,73,185.19519992656609,11.494953244406702]
[null,null,null,null,null,null,null,74,-337.51482093515813,6.6782100913107323]
[null,null,null,null,null,null,null,75,185.29940525162269,11.560638276545788]
[null,null,null,null,null,null,null,76,-532.04678330305933,3.8928255289990332]
[null,null,null,null,null,null,null,77,1422.8509347337986,20.156836457987957]
[null,null,null,null,null,null,null,78,841.45960775437754,16.744886792912151]
[null,null,null,null,null,null,null,79,1639.1664233534716,20.610347703832499]
[null,null,null,null,null,null,null,80,44.858433926482036,10.442173573690571]
[null,null,null,null,null,null,null,81,-927.85924973167243,0.8344599584268364]
[null,null,null,null,null,null,null,82,-612.80853944651176,3.4178740541921826]
[null,null,null,null,null,null,null,83,-559.82624324875007,4.7784076529484354]
[null,null,null,null,null,null,null,84,0.53897927839154192,10.004514011793209]
[null,null,null,null,null,null,null,85,-109.06026972662009,8.9860158396213521]
[null,null,null,null,null,null,null,86,697.75084364316456,15.211153359508689]
[null,null,null,null,null,null,null,87,960.242532968305,17.291369874019892]
[null,null,null,null,null,null,null,88,-172.09624573585808,8.4855582122723927]
[null,null,null,null,null,null,null,89,-502.28690573464951,5.1470713903164933]
[null,null,null,null,null,null,null,90,104.03538141775553,10.873718469883876]
[null,null,null,null,null,null,null,91,-526.66847684931781,5.3079943332098534]
[null,null,null,null,null,null,null,92,560.47786332041551,14.249682629253613]
[null,null,null,null,null,null,null,93,277.9647718509944,12.10249764175102]
[null,null,null,null,null,null,null,94,1300.5404735989578,18.744170207752187]
[null,null,null,null,null,null,null,95,1356.6395592210743,19.480629130273151]
[null,null,null,null,null,null,null,96,1252.8871464840759,18.457470677295596]
[null,null,null,null,null,null,null,97,-579.20603236805016,4.2028288087453403]
[null,null,null,null,null,null,null,98,-755.92282775807473,2.8621351003136342]
[null,null,null,null,null,null,null,99,-561.95806180143973,4.3616071635417919]
[null,null,null,null,null,null,null,100,-539.14130432860145,5.0404617586059963]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}